MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Alpha Sort = 36606

View and edit SQL

Suggested facets: Artist Role, Object Date, Object Begin Date, Object End Date, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
255218 76.1.1 0 0 383852 Drawings and Prints 11 Plate 356 Brown Pelican. Pelicanus Fuscus. Young, First Winter         Birds of America, plate CCCCXXI [421] 1305 Artist|Etcher 1324 After John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1838 1838 1838 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 26 1/4 x 39 3/16 in. (66.6 x 99.5 cm) Gift of William E. Dodge Jr., 1876                       Plates 226   Metropolitan Museum of Art, New York, NY 1
255221 76.1.2 0 0 383855 Drawings and Prints 11 Plate 356 Bird of Washington. Falco Washingtonii         Birds of America, plate XI [11] 1306 Artist|Etcher 1324 After John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1827 1827 1827 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 39 x 26 in. (99.1 x 66 cm) Gift of William E. Dodge Jr., 1876                       Plates 226   Metropolitan Museum of Art, New York, NY 1
255222 76.1.3 0 0 383856 Drawings and Prints 11 Plate 356 Brasilian Caracara Eagle. Polyborus Vulgaris         Birds of America, plate CLXI [61] 1307 Artist|Etcher 1324 After John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1833 1833 1833 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 39 1/4 x 26 1/8 in. (99.7 x 66.4 cm) Gift of William E. Dodge Jr., 1876                       Plates 226   Metropolitan Museum of Art, New York, NY 1
255223 76.1.4 0 0 383857 Drawings and Prints 11 Plate 356 Winter Hawk. Falco Hyemalis / Bull-frog. Rana tuurinu         Birds of America, plate LXXI [71] 1308 Artist|Etcher 1324 After John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1829 1829 1829 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 26 3/16 x 39 3/16 in. (66.5 x 99.5 cm) Gift of William E. Dodge Jr., 1876                       Plates 226   Metropolitan Museum of Art, New York, NY 1
255224 76.1.5 0 0 383858 Drawings and Prints 11 Plate 356 Common Buzzard. Buteo Vulgaris / Marsh Hare. Sylvilagus Palustris Bachman         Birds of America, plate CCCLXXII [372] 1309 Artist|Etcher 1324 After John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1837 1837 1837 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 27 15/16 x 24 in. (71 x 61 cm) Gift of William E. Dodge Jr., 1876                       Plates 226   Metropolitan Museum of Art, New York, NY 1
255226 39.78 0 0 383860 Drawings and Prints 11 Plate 356 Canada Jay. Corus Canadensis / White Oak. Quercus alba         Birds of America, plate CVII [107] 1311 Artist|Engraver 452   John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1831 1831 1831 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 26 5/8 x 21 1/8 in. (67.6 x 53.7 cm) Gift of Miss Louise B. Graves, 1939                       Plates 226   Metropolitan Museum of Art, New York, NY 1
255227 61.679.1 0 0 383861 Drawings and Prints 11 Plate 356 Blue Jay. Corvus Cristatus         Birds of America, plate CII [102] 1312 Artist|Etcher 1324 After John James Audubon|Robert Havell Jr. American (born Haiti), Les Cayes (Saint-Domingue) 1785–1851 New York|American (born England), Reading 1793–1878 Tarrytown, New York   Audubon, John James|Havell, Robert, Jr. 36606 American, born Haiti|American, born England 2920 1785 |1793 1851 |1878 1831 1831 1831 Printing plate: etching and aquatint on copper, nickel plated and filled with brass paint 40938 plate: 26 7/16 x 21 1/16 in. (67.2 x 53.5 cm) Gift of Alonzo P. Boardman, 1961                       Plates 226   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 127.214ms · Data license: CC0 · Data source: metmuseum/openaccess